package com.fpd.model.bean;

import lombok.Data;
import java.math.BigDecimal;
import cn.afterturn.easypoi.excel.annotation.Excel;

/**
 * 律师函下载excel实体类
 */
@Data
public class ExportEmsExcel {

    //邮件号  空
    @Excel(name = "邮件号", orderNum = "0")
    private String billNo;

    //配货单  uuid 我们生成
    @Excel(name = "*配货单号", orderNum = "1")
    private String serialNumber;

    //客户订单号
    @Excel(name = "客户订单号", orderNum = "2")
    private String orderNumber;

    //寄件人姓名 '方明'
    @Excel(name = "*寄件人姓名", orderNum = "3")
    private String scustName;

    //寄件人联系方式 15377692142
    @Excel(name = "*寄件人联系方式", orderNum = "4")
    private String scustPhone;

    //寄件人联系方式2  空
    @Excel(name = "寄件人联系方式（2）", orderNum = "5")
    private String scustPhone2;

    //寄件人地址 武昌区中北路233号世纪大厦1201湖北赫诚律师事务所
    @Excel(name = "*寄件人地址", orderNum = "6")
    private String scustAddress;

    //寄件人公司 空
    @Excel(name = "寄件人公司", orderNum = "7")
    private String scustCompany;

    //寄件省 空
    @Excel(name = "寄件省", orderNum = "8")
    private String scustProvince;

    //寄件市 空
    @Excel(name = "寄件市", orderNum = "9")
    private String scustCity;

    //寄件县 空
    @Excel(name = "寄件县", orderNum = "10")
    private String scustCounty;

    //寄件人邮编 空
    @Excel(name = "寄件人邮编", orderNum = "11")
    private String scustPostCode;

    //收件人姓名
    @Excel(name = "*收件人姓名", orderNum = "12")
    private String tcustName;

    //收件人联系方式
    @Excel(name = "*收件人联系方式", orderNum = "13")
    private String tcustPhone;

    //收件人联系方式2  ''
    @Excel(name = "收件人联系方式（2）", orderNum = "14")
    private String tcustPhone2;

    //收件人地址
    @Excel(name = "*收件人地址", orderNum = "15")
    private String tcustAddress;

    //收件人公司 ''
    @Excel(name = "收件人公司", orderNum = "16")
    private String tcustCompany;

    //收件省/直辖市  空
    @Excel(name = "到件省/直辖市", orderNum = "17")
    private String tcustProvince;

    //收件城市   空
    @Excel(name = "到件城市", orderNum = "18")
    private String tcustCity;

    //收件县/区   空
    @Excel(name = "到件县/区", orderNum = "19")
    private String tcustCounty;

    //收件人邮编  空
    @Excel(name = "收件人邮编", orderNum = "20")
    private String tcustPostCode;

    //物品重量 0.06
    @Excel(name = "物品重量", orderNum = "21")
    private String weight;

    //物品长度 空
    @Excel(name = "物品长度", orderNum = "22")
    private String length;

    //物品宽度 空
    @Excel(name = "物品宽度", orderNum = "23")
    private String wide;

    //物品高度  空
    @Excel(name = "物品高度", orderNum = "24")
    private String height;

    //打单时间 空
    @Excel(name = "打单时间", orderNum = "25")
    private String createTime;

    //备注 '无法联系时，请按收件地址派件到家里或村委会，有问题联系027－52348388/13329735134签收后备注代收关系'
    @Excel(name = "备注", orderNum = "26")
    private String remark;

    //业务类型 '特快专递'
    @Excel(name = "业务类型", orderNum = "27")
    private String businessType;

    //代收货款 空
    @Excel(name = "代收货款", orderNum = "28")
    private BigDecimal collectionAmount;

    //收件人付费 空
    @Excel(name = "收件人付费", orderNum = "29")
    private BigDecimal pay;

    //应收货款/邮资 空
    @Excel(name = "应收货款/邮资", orderNum = "30")
    private BigDecimal postFee;

    //应收货款/邮资(大写) 空
    @Excel(name = "应收货款/邮资（大写）", orderNum = "31")
    private String postFeeString;

    //内件性质 '文件'
    @Excel(name = "内件性质", orderNum = "32")
    private String innerType;

    //内件数 空
    @Excel(name = "内件数", orderNum = "33")
    private Integer innerCount;

    //内件信息 '湖北赫诚律师事务所   律师函   已验视'
    @Excel(name = "内件信息", orderNum = "34")
    private String innerInfo;

    //留白一 空
    @Excel(name = "留白一", orderNum = "35")
    private String leftBlank1;

    //留白二 空
    @Excel(name = "留白二", orderNum = "36")
    private String leftBlank2;

    //付费类型 空
    @Excel(name = "付费类型", orderNum = "37")
    private String feeType;

    //所负责任 空
    @Excel(name = "所负责任", orderNum = "38")
    private String duty;

    //保价金额 空
    @Excel(name = "保价金额", orderNum = "39")
    private BigDecimal insuranceCharge;

    //保险金额 空
    @Excel(name = "保险金额", orderNum = "40")
    private BigDecimal riskCharge;

    //其他费 空
    @Excel(name = "其他费", orderNum = "41")
    private BigDecimal otherFee;

    //打印份数 空
    @Excel(name = "打印份数", orderNum = "42")
    private String printCount;

    //高考录取通知书 空
    @Excel(name = "高考录取通知书", orderNum = "43")
    private String universityOffer;

    //案号1 空
    @Excel(name = "案号1", orderNum = "44")
    private String caseNumber1;

    //案号2 空
    @Excel(name = "案号2", orderNum = "45")
    private String caseNumber2;

    //委托方
    @Excel(name = "委托方", orderNum = "46")
    private String entrust;

    //委案日期
    @Excel(name = "委案日期", orderNum = "47")
    private String noticeDate;

    //委托方项目组
    @Excel(name = "委托方项目组", orderNum = "48")
    private String groupName;

    //客服姓名
    @Excel(name = "客服姓名", orderNum = "49")
    private String careName;

    //申请时间
    @Excel(name = "申请时间", orderNum = "50")
    private String postDate;

    //案件号
    @Excel(name = "案件号", orderNum = "51")
    private String contractNumber;
    
    //案件号
    @Excel(name = "年龄段", orderNum = "52")
    private String agePartStr;
    
    //案件号
    @Excel(name = "发函地址", orderNum = "53")
    private String addressType;
}
